Fast sensor data insertion using memory logging

The sensor database system to which new sensor data frequently arrive should provide fresh data to its clients. Toward this end, fast sensor data insertion to the database is essential. The bottleneck of the conventional sensor data insertion is disk logging that writes a log record to disk before accessing buffer pool in memory. The purpose of this paper is to show fast sensor data insertion using memory logging that writes a log record to neighboring nodes’ memory. We further propose multiple memory logging which improves the speed of memory logging and the persistence of the memory log records. To accomplish speed improvement, we try two approaches, (1) UDP(User Datagram Protocol), and (2) BPF(Berkeley Packet Filter). To accomplish persistence improvement, we introduce several log servers and a log server manager that manages them. The result of our experiment shows that single memory logging is about 5.20 time and multiple memory logging is about 1.67 times faster than disk logging in the maximum case.